screen                1                                 MENU                                                                                                                                 To select an item from the menu, you must enter the letter or number       to the left of the menu item.  For example, if you wish to add data to a file   which may or may not already exist, you must                                               1) hit the "1" key                                                              2) hit the enter key                                                                                                                                      F2  - will exit the WILKES DATA BASE and return you to OS/2                   ctl+a - will display 'system' help based on where you are                       ctl+b - will display 'user' help based on last screen name entered                                                                                                ESC - key will exit the WILKES DATA BASE and return you to OS/2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            screen                2                                 SCREEN ADD                                                                                                                           Screen name - may be up to 8 characters and may have embedded blanks.      The name will appear in lower case whetheryou enter in upper or lower case.     The name may be entered as an asterisk '*' in the first position to 'remember'  the last screen name used if there was a previous screen name to remember.                                                                                           F1  - will update the screen information                                        F2  - will refresh the 'MENU' screen and ignore screen addition               ctl+a - will display 'system' help based on where you are                       ctl+b - will display 'user' help based on last screen name entered                                                                                                ESC - key will refresh the 'MENU' screen and ignore screen addition                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        screen                3                                 SCREEN UPDATE                                                                                                                        Screen name - may be up to 8 characters and may have embedded blanks.      The name will appear in lower case whetheryou enter in upper or lower case.     The name may be entered as an asterisk '*' in the first position to 'remember'  the last screen name used if there was a previous screen name to remember.           A screen by this name must already have been setup with the screen         functions.                                                                                                                                                           F1  - will update the screen information                                        F2  - will refresh the 'MENU' screen ignoring unsaved changes to the                  current (displayed) record                                              ctl+a - will display 'system' help based on where you are                       ctl+b - will display 'user' help based on last screen name entered                                                                                                ESC - key will refresh the 'MENU' screen ignoring unsaved changes to the              current (displayed) record                                                                                                                                                                                                           screen                4                                 SCREEN COPY                                                                                                                          Screen name - may be up to 8 characters and may have embedded blanks.      The name will appear in lower case whetheryou enter in upper or lower case.     The name may be entered as an asterisk '*' in the first position to 'remember'  the last screen name used if there was a previous screen name to remember.           A screen by this name must already have been setup with the screen         functions.                                                                           New Screen name - must not already exist.  The rules for this screen name  are the same as for 'Screen name' above.                                                                                                                             F1  - Perform the copy operation                                                F2  - will refresh the 'MENU' screen without copying the file                 ctl+a - will display 'system' help based on where you are                       ctl+b - will display 'user' help based on last screen name entered                                                                                                ESC - key will refresh the 'MENU' screen without copying the file                                                                                                                                                                          screen                5                                 SCREEN DELETE                                                                                                                        Screen name - may be up to 8 characters and may have embedded blanks.      The name will appear in lower case whetheryou enter in upper or lower case.     The name may be entered as an asterisk '*' in the first position to 'remember'  the last screen name used if there was a previous screen name to remember.           A screen by this name must already have been setup with the screen         functions.                                                                                                                                                           F1  - Perform the delete operation                                              F2  - will refresh the 'MENU' screen without deleting the screen              ctl+a - will display 'system' help based on where you are                       ctl+b - will display 'user' help based on last screen name entered                                                                                                ESC - key will refresh the 'MENU' screen without deleting the screen                                                                                                                                                                                                                                                                                                                                       screen                6                                 SCREEN-DATA REFORMAT                                                                                                                 Old screen name - is the name of the screen wich works with the old file                          name.                                                         Old file name - is the name of the OS/2 file which works with the old                           screen name.                                                    New screen name - is the name of the screen which depicts the way the                             new data file is to look.                                     New file name - is the name of the OS/2 file to be built to the                                 'new screen' specifications.                                                                                                                    F1  - Perform the reformat operation                                            F2  - will refresh the 'MENU' screen without performing the reformat          ctl+a - will display 'system' help based on where you are                       ctl+b - will display 'user' help based on last screen name entered                                                                                                ESC - key will refresh the 'MENU' screen without performing the reformat                                                                                                                                                                   screen                9                                 SET VIDEO ATTRIBUTES                                                                                                                 Choose the numbers to match the displayed numbers (1-127) based on the     way the displayed number looks (background/forground colors).  The various      categories (normal, highlight, underscore, reverse video, highlight and         underscore) correspond to the attirbutes for the fields set up with the         screen functions.                                                                                                                                                    F1  - will update the video attributes and return to the 'MENU' screen          F2  - will refresh the 'MENU' screen ignoring video changes                   ctl+a - will display 'system' help based on where you are                       ctl+b - will display 'user' help based on last screen name entered                                                                                                ESC - key will refresh the 'MENU' screen ignoring video changes                                                                                                                                                                                                                                                                                                                                                                                                                            screen               10                                 DATA ADD                                                                                                                             Screen name - is the name of a previously painted screen.                       File name - is the OS/2 file name to which records are to be added.             NOTE: if 'screen name' or 'file name' begins with '*' the last used                   'screen name' or 'file name' will be assumed.                                                                                                             F1  - will add the record and clear the fields not defined as copy              F2  - will refresh the 'MENU' screen without adding the current record        ctl+a - will display 'system' help based on where you are                       ctl+b - will display 'user' help based on last screen name entered                                                                                                ESC - key will refresh the 'MENU' screen without adding the current                   record                                                                                                                                                                                                                                                                                                                                                                                                                                                                               screen               11                                 DATA LOOKUP/UPDATE                                                                                                                   Screen name - is the name of a previously painted screen.                       File name - is the OS/2 file name to which records are to be added.             Field name - is the name of the field which the search is based on.             CMP - denotes how the file value is to be compared to the 'VALUE'.                    '>' = greater than, '<' = less than, '>=' = greater or equal,                   '<=' = less or equal, '=' = equal, '<>' = not equal.                      VALUE - to compare to the file's record's value.                                NOTE: if 'screen name' or 'file name' begins with '*' the last used                   'screen name' or 'file name' will be assumed.                           SF=shifted function key, AF=Alt key and function key                            F1-F8    Display next record selected (if no more - return to 'MENU')           SF1-SF8  Display previous record selected (if no more - return to 'MENU')       F9       Go to beginning of file           F10     Go to end of file            SF9      Delete, go to next/previous       SF10    Return to 'MENU' screen      AF1      Add record to the file            AF3     Perform indexed lookup     ctl+a      Display System Help             ctl+b     Display user help            ESC      Return to 'MENU' screen                                             screen               12                                 DATA DISPLAY/UPDATE                                                                                                                  Screen name - is the name of a previously painted screen.                       File name - is the OS/2 file name to which records are to be added.                                                                                             NOTE: if 'screen name' or 'file name' begins with '*' the last used                   'screen name' or 'file name' will be assumed.                                                                                                                      UNSHIFTED/SHIFTED         UNSHIFTED/SHIFTED                                      UPDATE AND MOVE                 MOVE                                                       +1/-1  F1|F2  +1/-1                                                           +10/-10  F3|F4  +10/-10                                                       +100/-100  F5|F6  +100/-100                                                   +1000/-1000  F7|F8  +1000/-1000                                 front of file/delete record  F9|F10 end of file/return to 'MENU'                      display system help ctl+a|ctl+b display user help                                                                                                        Alt F1 = Add record                                                             Alt F3 = Indexed lookup                                                      screen               13                                 DATA PRINT                                                                                                                           Screen name - is the name of a previously painted screen.                       File name - is the OS/2 file name to which records are to be added.             NOTE: if 'screen name' or 'file name' begins with '*' the last used                   'screen name' or 'file name' will be assumed.                             F1=Accept screen  F2=Return to 'MENU'  ctl+a=system help  ctl+b=user help             ESC=Return to 'MENU'                                                      Print format screen - Allows you to enter the basic print information      which may be saved in order to keep from having to enter the same information   again (SAVE SPECIFICATIONS ?).  The report name entered will be the OS/2 file   name of the stored report specifications.                                            Header lines screen - allows you to paint the header lines, possibly       with the information to interpret the detail lines.                                  Detail lines screen - allows you to paint the detail lines with any        constants you wish to always appear on the detail lines.                             Print detail screen - lets you choose the fields to be printed and the     position on the detail line(s) where they are to appear.  Field totals,         sub-totals and break on field value change is specified here.                   screen               14                                 DATA COPY                                                                                                                            Screen name - is the name of a previously painted screen.                       File name - is the OS/2 file name to which records are to be added.             New file name - file created to hold the copied records.                        NOTE: if 'screen name' or 'file name' begins with '*' the last used                   'screen name' or 'file name' will be assumed.                             Copy file - copies the entire file (except deleted entries) into the                        new file.                                                           Copy manual - allows you to browse through the file copying the records                       you wish (F1/SF1(+1/-1), F3/SF3(+10/-10), F5/SF5(+100/-100),                    F7/SF7(+1000/-1000)), skipping records (F2/SF2(+1/-1), SF9,                     F4/SF4(+10/-10), F6/SF6(+100/-100), F8/SF8(+1000/-1000)),                       move to front of file (F9), to the end of file (F10), add                       a record (Alt F1) or perform indexed lookup (Alt F3 - field                     must be indexed).                                                 Selector Copy - where you enter selection criteria for the records which                        may be copied into the new file.                                Index Copy - Copies undeleted records in index order (must be indexed).    screen               15                                 DATA SORT                                                                                                                            Screen name - is the name of a previously painted screen.                       File name - is the OS/2 file name to which records are to be added.             New file name - file created to hold the sorted records.                        NOTE: if 'screen name' or 'file name' begins with '*' the last used                   'screen name' or 'file name' will be assumed.                             The sort will allows you to sort on up to five (5) fields in mixed         forward or reverse order.  You must specify at least one field name and its     sort order (forward or reverse).  When you have entered the number of fields    you wish to sort on hit F1 to start the sort.                                                                                                                        F1  - Perform the sort operation                                                F2  - Returns to the 'MENU' screen without performing the sort                ctl+a - Displays system help for the 'data sort' screen                         ctl+b - Displays user help for the last screen name entered                                                                                                       ESC - Returns to the 'MENU' screen without performing the sort                                                                                             screen               16                                 COLUMN ARITHMETIC                                                                                                                    Screen name - is the name of a previously painted screen.                       File name - is the OS/2 file name to which records are to be added.             NOTE: if 'screen name' or 'file name' begins with '*' the last used                   'screen name' or 'file name' will be assumed.                                                                                                             The purpose of 'column arithmetic' is to perform arithmetic operations     on a given field for all records in the file.  The allowable operations are     addition, subtraction, multiplication and division.  You may perform these      operations with either another field in the same record or with a constant.     when the operations are performed with a constant, the constant is preceeded    with a pound sign '#'.  Fields may be equated to other fields or constants.                                                                                          F1  - Perform the column arithmetic operation                                   F2  - Returns to the 'MENU' screen without performing the arithmetic          ctl+a - Displays system help for the 'column arithmetic' screen                 ctl+b - Displays user help for the last screen name entered                       ESC - Returns to the 'MENU' screen without performing the arithmetic       screen               17                                 APPEND FILE                                                                                                                          File to append to - will have the 'file to append' file appended to the                             end of it.  This may be any OS/2 file.                      File to append - may be any OS/2 file.  Note that the files are not                              checked in any way to be sure that they represent                               similar data.                                                                                                                                  F1  - Perform the append operation                                              F2  - Returns to the 'MENU' screen without performing the append              ctl+a - Displays system help for the 'column arithmetic' screen                 ctl+b - Displays user help for the last screen name entered                       ESC - Returns to the 'MENU' screen without performing the append                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           screen               18                                 PRINT FORMAT SCREEN                                                                                                              Report name is the OS/2 file name for the report file, if saved.                New specifications  - 'y' or 'n'.                                               Save specifications - 'y' or 'n'.                                               Colums/line   - 80-240.      Lines/page - # lines on page.                      Header        - 'y' or 'n'.  #header lines - at top of each page.               Detail        - 'y' or 'n'.  #detail lines - for each record.                   Page break on field change, Totaling, Sub-totaling - 'y' or 'n' (override).     Print date    - 'y' or 'n'.  to place date in a header line.                    Print time    - 'y' or 'n'.  to place time in a header line.                    Print page #  - 'y' or 'n'.  to place page # in a header line.                  Print record# - 'y' or 'n'.  to place (0 relative) record # in a detail line.   Omit blank detail lines - 'y' or 'n'.  If 'y', blank lines are not printed.          F1  - Accept this screen and continue to the next screen                        F2  - Returns to the 'MENU' screen without performing the print               ctl+a - Displays system help for the 'print format screen' screen               ctl+b - Displays user help for the last screen name entered                       ESC - Returns to the 'MENU' screen without performing the print           screen               19                                 HEADER LINES SCREEN                                                                                                                  You may paint the header lines here.  If you requested that the date,      time and/or page number be printed in the previous screen, MO/DA/YR, HR:MN      and/or nnnnn respectively will be displayed in the requested position(s) in     this display.  The actual date, time or page number will be printed in these    positions at print time.  Place any constant information in these lines you     wish.  For instance: a title on the first line or column names for the detail   information.                                                                                                                                                         F1  - Accept this screen and continue to the next screen                        F2  - Returns to the 'MENU' screen without performing the print               ctl+a - Displays system help for the 'header lines screen' screen               ctl+b - Displays user help for the last screen name entered                       ESC - Returns to the 'MENU' screen without performing the print                                                                                                                                                                                                                                                                                                                                            screen               20                                 DETAIL LINES SCREEN                                                                                                                  You may paint the detail lines here.  If you requested that the record     number be printed in a detail line, you will see nnnnn where the record         number will be printed.  nnnnn will be overwritten at print time with the       actual record number in the file (beginning with 0).  The line number and       column number is displayed at the bottom of the screen for your convenience.         The detail lines will be printed unless the line is all spaces and you     requested that blank lines not be printed.                                                                                                                           F1  - Accept this screen and continue to the next screen                        F2  - Returns to the 'MENU' screen without performing the print               ctl+a - Displays system help for the 'detail lines screen' screen               ctl+b - Displays user help for the last screen name entered                       ESC - Returns to the 'MENU' screen without performing the print                                                                                                                                                                                                                                                                                                                                            screen               21                                 PRINT DETAIL SCREEN                                                                                                                  The field names are displayed on the left.  The field length at the        bottom of the screen is for the field line the cursor is on.  The colums have   the following meanings.                                                              P (print field) - 'y' or 'n'.    SL (subtotal level) - 1-9 break/order.         T (total field) - 'y' or 'n'.    PB (page break on field) - 'y' or 'n'.         S (subtotal fields with break    #L/#Col (line#/Column#) - line and col            on SL fields) - 'y' or 'n'.      in detail line (max. 5 per field).                                                                                          F1  - Accept this screen and print the report                                   F2  - Returns to the 'MENU' screen without performing the print               ctl+a - Displays system help for the 'detail lines screen' screen               ctl+b - Displays user help for the last screen name entered                       ESC - Returns to the 'MENU' screen without performing the print                                                                                                                                                                                                                                                                                                                                            screen               22                                 INDEXING                                                                                                                             DISPLAY INDEXES (y or n)? - if 'y' the indexes defined will be displayed.                                   if 'n' the following questions are asked.           SCREEN NAME ? - name of a previously defined screen.                            FILE NAME ?   - of file to be indexed.                                          FIELD NAME ?  - to index the file on (only one field).                          INDEX FILE NAME ? - OS/2 file name of the index file.                           BUILD (b) OR DELETE (d) ? - to either build or delete the index file.                                                                                           F1  - Accept this screen and index the file                                     F2  - Returns to the 'MENU' screen without performing the indexing            ctl+a - Displays system help for the 'indexing' screen                          ctl+b - Displays user help for the last screen name entered                       ESC - Returns to the 'MENU' screen without performing the indexing                                                                                                                                                                                                                                                                                                                                         screen               23                                 SYSTEM REQUESTS                                                                                                                      The system function will allow you to perform most of the OS/2 functions   you are used to using (full screen prompt).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          F1  - Accept this screen and index the file                                     F2  - Returns to the 'MENU' screen without performing the indexing            ctl+a - Displays system help for the 'indexing' screen                          ctl+b - Displays user help for the last screen name entered                       ESC - Returns to the 'MENU' screen without performing the indexing                                                                                                                                                                                                                                                                                                                                         